Home Tech info Quiz technology

[QUIZ] Test your understanding of SQL - Part 5

Multiple-choice questions on SQL help you familiarize and review useful knowledge for work and learning SQL language.

  1. Question 1: Which of the following SQL statements has the correct syntax?
    1. SELECT CustomerName, COUNT (CustomerName) FROM ORDER BY OrdersName CustomerName
    2. SELECT CustomerName, COUNT (CustomerName) FROM Orders GROUP BY CustomerName
    3. SELECT CustomerName, COUNT (CustomerName) FROM Orders
  2. Question 2: Which of the following SQL statements has the correct syntax?
    1. SELECT * FROM Table1 WHERE Column1 = = 10
    2. SELECT * FROM Table1 WHERE Column1 => 10
    3. SELECT * FROM Table1 WHERE Column1> = 10
  3. Question 3: Which SQL statements insert data into the Projects table?
    1. SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')
    2. INSERT Projects VALUES ('Content Development', 'Website content development project')
    3. INSERT Projects ('Content Development', 'Website content development project')
    4. INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')
  4. Question 4: Which of the following SQL statements has the correct syntax?
    1. SELECT Username, Password WHERE Username = 'user1'
    2. SELECT Username AND Password FROM Users
    3. SELECT Username, Password FROM Users
  5. Question 5: Which SQL keyword is used to only retrieve unique values?
    1. DISTINCTIVE
    2. UNIQUE
    3. DISTINCT
    4. DIFFERENT
  6. What does sentence 6: VIEW mean in SQL?
    1. Is a database diagram.
    2. A virtual table in a database with content defined through a certain SQL statement.
    3. Is a stored procedure specifically performed when certain events occur.
  7. Question 7: Which international standard does SQL meet?
    1. Only ISO (International Organization for Standardization)
    2. Only meet ANSI (American National Standards Institute) standards
    3. Meets both ISO and ANSI standards
  8. Question 8: What does DML mean?
    1. Different Mode Level
    2. Data Manipulation language
    3. Data Mode Lane
    4. Data Model Language
  9. Question 9: Which of the following SQL statements will generate errors when executing?
    1. CREATE DATABASE students
    2. CREATE DATABASE students;
    3. tạo cơ sở dữ liệu nếu không có viên
    4. IF NOT EXISTS CREATE DATABASE STUDENTS;
  10. Question 10: The ORDER clause is used to sort records in ascending or descending order.
    1. It's correct
    2. False
  11. Question 11: Which of the following statements will successfully execute?
    1. SELECT customer FROM customer_name;
    2. SELECT FROM customers customer name;
    3. SELECT customer_name FROM customers ORDER BY zone WHERE cat_id = 12;
    4. SELECT customer_name FROM customers WHERE cat_id = 12 ORDER BY cat_id;
  12. Question 12: GROUP BY command cannot be used with aggregation functions.
    1. It's correct
    2. False
  13. Question 13: In the following functions, what is the aggregate function in SQL?
    1. CURDATE ()
    2. COUNT
    3. AVERAGE
    4. MAXIMUM
  14. Question 14: The UNION command is used to combine results from multiple queries into a result set.
    1. It's correct
    2. False
  15. Question 15: What is the correct order of the ">" and "=" operators when you want to specify greater or equal search conditions?
    1. > =
    2. =>
    3. Both answers are correct
learn sql sql quizzes database test quiz sql check sql sql knowledge sql test sql exercises
4 ★ | 1 Vote
« PREV : [QUIZ] Test your...
[QUIZ] Test your... : NEXT »
Read More
Maybe you are interested